
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<%@ page import="java.io.* ,java.util.*, java.sql.*, Login.*"%>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>:: Shanti Chakra Foundation ::</title>
<link href="style.css" rel="stylesheet" type="text/css">

</head>
<script>

function validate(form1)
	{
		if (form1.rcheck.checked == false)
		{		alert("Select any Record");
				return false;
		}
	}
	
</script>

<body bgcolor="#0D62A2">
<p><a href = "ActiveMembers.jsp"> Back</a>
  <%
  String searchmem = request.getParameter("searchmem");
MySqlConnector ms = new MySqlConnector();
PreparedStatement stmt1;
ResultSet rs1 ;
ms.Connect();
// All members
String q = " SELECT memberid, name, surname, sex, mobile, email FROM registration where status = 1 and (name like '"+searchmem+"%' or memberid = '"+searchmem+"' ); " ;
 System.out.println("query in list members1"+q);
stmt1 = ms.Connect().prepareStatement(q);
System.out.println("statement is "+stmt1);
rs1 = stmt1.executeQuery();
%>
</p>

<form name="form1" method="post" action = "ManageMembers" onSubmit="return validate(this.name)">
  <table width="679" border="1" align="left"  bordercolor="#FFFF99" class="greenlink_no_left_padding">
<tr>
<td height="33" colspan="8" bgcolor="#D8F2C9" class="style4"> 
<h2 align="center" class="bluetext">Active Search Members List </h2>	</td>
</tr>
<tr></tr>
<tr>
<td class="style12"><span class="style14">Member ID </span></td>
<td class="style13">Full Name </td>
<td class="style13">Gender</td>
<td class="style12"><span class="style13">Mobile</span></td>
<td class="style12"><span class="style13">Mail ID </span></td>
</tr>
<% while(rs1.next()==true)
{%>
<tr>
  <td width="94"><span class="style8"><%=rs1.getString(1)%> &nbsp;</span></td>
<td width="137"><span class="style8"><%=rs1.getString(2)%>. <%=rs1.getString(3)%> </span></td>
<td width="101"><span class="style8"><%=rs1.getString(4)%></span></td>
<td width="102"><span class="style8"><%=rs1.getString(5)%></span></td>
<td width="180"><span class="style8"><%=rs1.getString(6)%></span></td>
</tr> <%}%>
</table>

</form>
</body>
</html>